Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 906292 |
| Missing cells | 157616 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 110.6 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 4 |
time has a high cardinality: 37662 distinct values | High cardinality |
gameId is highly correlated with team | High correlation |
frameId is highly correlated with s and 1 other fields | High correlation |
s is highly correlated with dis | High correlation |
a is highly correlated with s | High correlation |
dis is highly correlated with s | High correlation |
team is highly correlated with gameId | High correlation |
nflId has 39404 (4.3%) missing values | Missing |
jerseyNumber has 39404 (4.3%) missing values | Missing |
o has 39404 (4.3%) missing values | Missing |
dir has 39404 (4.3%) missing values | Missing |
s has 60334 (6.7%) zeros | Zeros |
a has 56293 (6.2%) zeros | Zeros |
dis has 60300 (6.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-02 15:02:04.237892 |
|---|---|
| Analysis finished | 2022-11-02 15:03:26.588502 |
| Duration | 1 minute and 22.35 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2021102393 |
| Minimum | 2021102100 |
|---|---|
| Maximum | 2021102500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 2021102100 |
|---|---|
| 5-th percentile | 2021102100 |
| Q1 | 2021102402 |
| median | 2021102405 |
| Q3 | 2021102408 |
| 95-th percentile | 2021102500 |
| Maximum | 2021102500 |
| Range | 400 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 80.41104086 |
|---|---|
| Coefficient of variation (CV) | 3.978573334 × 10-8 |
| Kurtosis | 8.395453966 |
| Mean | 2021102393 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -2.871199535 |
| Sum | 1.83170893 × 1015 |
| Variance | 6465.935492 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 2021102400 | 90735 | |
| 2021102405 | 80178 | |
| 2021102401 | 77970 | |
| 2021102404 | 73163 | |
| 2021102500 | 71323 | |
| 2021102403 | 71277 | |
| 2021102402 | 71047 | |
| 2021102406 | 66516 | 7.3% |
| 2021102407 | 64492 | 7.1% |
| 2021102409 | 64354 | 7.1% |
| Other values (3) | 175237 |
| Value | Count | Frequency (%) |
| 2021102100 | 57431 | |
| 2021102400 | 90735 | |
| 2021102401 | 77970 | |
| 2021102402 | 71047 | |
| 2021102403 | 71277 | |
| 2021102404 | 73163 | |
| 2021102405 | 80178 | |
| 2021102406 | 66516 | |
| 2021102407 | 64492 | |
| 2021102408 | 63250 |
| Value | Count | Frequency (%) |
| 2021102500 | 71323 | |
| 2021102410 | 54556 | |
| 2021102409 | 64354 | |
| 2021102408 | 63250 | |
| 2021102407 | 64492 | |
| 2021102406 | 66516 | |
| 2021102405 | 80178 | |
| 2021102404 | 73163 | |
| 2021102403 | 71277 | |
| 2021102402 | 71047 |
playId
Real number (ℝ≥0)
| Distinct | 832 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2176.401355 |
| Minimum | 55 |
|---|---|
| Maximum | 4255 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 55 |
|---|---|
| 5-th percentile | 319 |
| Q1 | 1170 |
| median | 2227 |
| Q3 | 3233 |
| 95-th percentile | 3904 |
| Maximum | 4255 |
| Range | 4200 |
| Interquartile range (IQR) | 2063 |
Descriptive statistics
| Standard deviation | 1169.259945 |
|---|---|
| Coefficient of variation (CV) | 0.5372446318 |
| Kurtosis | -1.211676161 |
| Mean | 2176.401355 |
| Median Absolute Deviation (MAD) | 1031 |
| Skewness | -0.09884512439 |
| Sum | 1972455137 |
| Variance | 1367168.819 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2293 | 4646 | 0.5% |
| 2855 | 4025 | 0.4% |
| 3244 | 3427 | 0.4% |
| 385 | 3220 | 0.4% |
| 3744 | 3151 | 0.3% |
| 1177 | 3059 | 0.3% |
| 1415 | 2921 | 0.3% |
| 3971 | 2875 | 0.3% |
| 2035 | 2852 | 0.3% |
| 3392 | 2852 | 0.3% |
| Other values (822) | 873264 |
| Value | Count | Frequency (%) |
| 55 | 736 | 0.1% |
| 56 | 2346 | |
| 61 | 736 | 0.1% |
| 62 | 1035 | |
| 64 | 897 | 0.1% |
| 75 | 989 | |
| 78 | 759 | 0.1% |
| 85 | 874 | 0.1% |
| 94 | 989 | |
| 96 | 805 | 0.1% |
| Value | Count | Frequency (%) |
| 4255 | 782 | |
| 4226 | 966 | |
| 4222 | 943 | |
| 4201 | 920 | |
| 4198 | 851 | |
| 4180 | 966 | |
| 4177 | 989 | |
| 4123 | 989 | |
| 4101 | 1311 | |
| 4077 | 713 |
| Distinct | 974 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 39404 |
| Missing (%) | 4.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46021.23712 |
| Minimum | 25511 |
|---|---|
| Maximum | 54006 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 25511 |
|---|---|
| 5-th percentile | 38557 |
| Q1 | 42765 |
| median | 46094 |
| Q3 | 48455 |
| 95-th percentile | 53505 |
| Maximum | 54006 |
| Range | 28495 |
| Interquartile range (IQR) | 5690 |
Descriptive statistics
| Standard deviation | 4982.508709 |
|---|---|
| Coefficient of variation (CV) | 0.1082654231 |
| Kurtosis | 0.005408309907 |
| Mean | 46021.23712 |
| Median Absolute Deviation (MAD) | 3195 |
| Skewness | -0.2144367005 |
| Sum | 3.989525821 × 1010 |
| Variance | 24825393.04 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43367 | 2516 | 0.3% |
| 39146 | 2516 | 0.3% |
| 45330 | 2516 | 0.3% |
| 46152 | 2516 | 0.3% |
| 53655 | 2516 | 0.3% |
| 53492 | 2516 | 0.3% |
| 46221 | 2516 | 0.3% |
| 47971 | 2516 | 0.3% |
| 47906 | 2510 | 0.3% |
| 41222 | 2510 | 0.3% |
| Other values (964) | 841740 | |
| (Missing) | 39404 | 4.3% |
| Value | Count | Frequency (%) |
| 25511 | 1072 | |
| 29550 | 1639 | |
| 29851 | 1405 | |
| 30842 | 359 | < 0.1% |
| 30869 | 1565 | |
| 33084 | 1539 | |
| 33107 | 1297 | |
| 33130 | 192 | < 0.1% |
| 33131 | 1167 | |
| 33138 | 643 | 0.1% |
| Value | Count | Frequency (%) |
| 54006 | 75 | < 0.1% |
| 53959 | 225 | < 0.1% |
| 53957 | 1255 | |
| 53953 | 1565 | |
| 53946 | 357 | < 0.1% |
| 53933 | 721 | |
| 53910 | 465 | 0.1% |
| 53900 | 1018 | |
| 53876 | 365 | < 0.1% |
| 53740 | 565 | 0.1% |
| Distinct | 175 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.2447721 |
| Minimum | 1 |
|---|---|
| Maximum | 175 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 22 |
| Q3 | 33 |
| 95-th percentile | 55 |
| Maximum | 175 |
| Range | 174 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 17.4079648 |
|---|---|
| Coefficient of variation (CV) | 0.7180090094 |
| Kurtosis | 6.558688704 |
| Mean | 24.2447721 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 1.655587672 |
| Sum | 21972843 |
| Variance | 303.0372386 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 21091 | 2.3% |
| 14 | 21091 | 2.3% |
| 24 | 21091 | 2.3% |
| 23 | 21091 | 2.3% |
| 2 | 21091 | 2.3% |
| 21 | 21091 | 2.3% |
| 20 | 21091 | 2.3% |
| 19 | 21091 | 2.3% |
| 18 | 21091 | 2.3% |
| 17 | 21091 | 2.3% |
| Other values (165) | 695382 |
| Value | Count | Frequency (%) |
| 1 | 21091 | |
| 2 | 21091 | |
| 3 | 21091 | |
| 4 | 21091 | |
| 5 | 21091 | |
| 6 | 21091 | |
| 7 | 21091 | |
| 8 | 21091 | |
| 9 | 21091 | |
| 10 | 21091 |
| Value | Count | Frequency (%) |
| 175 | 23 | |
| 174 | 23 | |
| 173 | 23 | |
| 172 | 23 | |
| 171 | 23 | |
| 170 | 23 | |
| 169 | 23 | |
| 168 | 23 | |
| 167 | 23 | |
| 166 | 23 |
| Distinct | 37662 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 2021-10-24T17:42:21.300 | 69 |
|---|---|
| 2021-10-24T17:42:22.400 | 69 |
| 2021-10-24T17:42:22.600 | 69 |
| 2021-10-24T17:42:22.700 | 69 |
| 2021-10-24T17:42:22.800 | 69 |
| Other values (37657) |
Length
| Max length | 23 |
|---|---|
| Median length | 23 |
| Mean length | 23 |
| Min length | 23 |
Characters and Unicode
| Total characters | 20844716 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2021-10-22T00:23:17.300 |
|---|---|
| 2nd row | 2021-10-22T00:23:17.400 |
| 3rd row | 2021-10-22T00:23:17.500 |
| 4th row | 2021-10-22T00:23:17.600 |
| 5th row | 2021-10-22T00:23:17.700 |
Common Values
| Value | Count | Frequency (%) |
| 2021-10-24T17:42:21.300 | 69 | < 0.1% |
| 2021-10-24T17:42:22.400 | 69 | < 0.1% |
| 2021-10-24T17:42:22.600 | 69 | < 0.1% |
| 2021-10-24T17:42:22.700 | 69 | < 0.1% |
| 2021-10-24T17:42:22.800 | 69 | < 0.1% |
| 2021-10-24T17:42:22.900 | 69 | < 0.1% |
| 2021-10-24T17:42:23.000 | 69 | < 0.1% |
| 2021-10-24T17:42:23.100 | 69 | < 0.1% |
| 2021-10-24T17:42:23.200 | 69 | < 0.1% |
| 2021-10-24T17:42:23.300 | 69 | < 0.1% |
| Other values (37652) | 905602 |
Length
| Value | Count | Frequency (%) |
| 2021-10-24t17:42:21.300 | 69 | < 0.1% |
| 2021-10-24t17:42:21.000 | 69 | < 0.1% |
| 2021-10-24t20:07:02.100 | 69 | < 0.1% |
| 2021-10-24t19:27:43.800 | 69 | < 0.1% |
| 2021-10-24t17:42:22.500 | 69 | < 0.1% |
| 2021-10-24t18:20:59.300 | 69 | < 0.1% |
| 2021-10-24t17:42:22.300 | 69 | < 0.1% |
| 2021-10-24t18:20:59.000 | 69 | < 0.1% |
| 2021-10-24t17:42:22.200 | 69 | < 0.1% |
| 2021-10-24t18:20:58.900 | 69 | < 0.1% |
| Other values (37652) | 905602 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4496869 | |
| 2 | 3803532 | |
| 1 | 2958652 | |
| - | 1812584 | |
| : | 1812584 | |
| 4 | 1305503 | 6.3% |
| T | 906292 | 4.3% |
| . | 906292 | 4.3% |
| 5 | 622587 | 3.0% |
| 3 | 601658 | 2.9% |
| Other values (4) | 1618163 | 7.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 15406964 | |
| Other Punctuation | 2718876 | 13.0% |
| Dash Punctuation | 1812584 | 8.7% |
| Uppercase Letter | 906292 | 4.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4496869 | |
| 2 | 3803532 | |
| 1 | 2958652 | |
| 4 | 1305503 | 8.5% |
| 5 | 622587 | 4.0% |
| 3 | 601658 | 3.9% |
| 9 | 453997 | 2.9% |
| 7 | 413147 | 2.7% |
| 8 | 395255 | 2.6% |
| 6 | 355764 | 2.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1812584 | |
| . | 906292 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1812584 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 906292 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19938424 | |
| Latin | 906292 | 4.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4496869 | |
| 2 | 3803532 | |
| 1 | 2958652 | |
| - | 1812584 | |
| : | 1812584 | |
| 4 | 1305503 | 6.5% |
| . | 906292 | 4.5% |
| 5 | 622587 | 3.1% |
| 3 | 601658 | 3.0% |
| 9 | 453997 | 2.3% |
| Other values (3) | 1164166 | 5.8% |
Latin
| Value | Count | Frequency (%) |
| T | 906292 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20844716 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4496869 | |
| 2 | 3803532 | |
| 1 | 2958652 | |
| - | 1812584 | |
| : | 1812584 | |
| 4 | 1305503 | 6.3% |
| T | 906292 | 4.3% |
| . | 906292 | 4.3% |
| 5 | 622587 | 3.0% |
| 3 | 601658 | 2.9% |
| Other values (4) | 1618163 | 7.8% |
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39404 |
| Missing (%) | 4.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.35768173 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 22 |
| median | 51 |
| Q3 | 75 |
| 95-th percentile | 95 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 53 |
Descriptive statistics
| Standard deviation | 29.80968417 |
|---|---|
| Coefficient of variation (CV) | 0.603952275 |
| Kurtosis | -1.321476716 |
| Mean | 49.35768173 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 0.03295354894 |
| Sum | 42787582 |
| Variance | 888.6172703 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21 | 19172 | 2.1% |
| 24 | 17369 | 1.9% |
| 2 | 17149 | 1.9% |
| 22 | 15586 | 1.7% |
| 51 | 15008 | 1.7% |
| 23 | 14680 | 1.6% |
| 72 | 14554 | 1.6% |
| 1 | 14406 | 1.6% |
| 29 | 13786 | 1.5% |
| 25 | 13630 | 1.5% |
| Other values (89) | 711548 | |
| (Missing) | 39404 | 4.3% |
| Value | Count | Frequency (%) |
| 1 | 14406 | |
| 2 | 17149 | |
| 3 | 2871 | 0.3% |
| 4 | 10684 | |
| 5 | 8293 | |
| 6 | 6249 | 0.7% |
| 7 | 3149 | 0.3% |
| 8 | 9373 | |
| 9 | 7514 | |
| 10 | 13284 |
| Value | Count | Frequency (%) |
| 99 | 11337 | |
| 98 | 11084 | |
| 97 | 12753 | |
| 96 | 8001 | |
| 95 | 7228 | |
| 94 | 11312 | |
| 93 | 7789 | |
| 92 | 8563 | |
| 91 | 13350 | |
| 90 | 12874 |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| BAL | 43395 |
|---|---|
| CIN | 43395 |
| football | 39404 |
| TEN | 38346 |
| KC | 38346 |
| Other values (22) |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 2.926798427 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2652534 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DEN |
|---|---|
| 2nd row | DEN |
| 3rd row | DEN |
| 4th row | DEN |
| 5th row | DEN |
Common Values
| Value | Count | Frequency (%) |
| BAL | 43395 | 4.8% |
| CIN | 43395 | 4.8% |
| football | 39404 | 4.3% |
| TEN | 38346 | 4.2% |
| KC | 38346 | 4.2% |
| GB | 37290 | 4.1% |
| WAS | 37290 | 4.1% |
| NYG | 34991 | 3.9% |
| CAR | 34991 | 3.9% |
| SEA | 34111 | 3.8% |
| Other values (17) | 524733 |
Length
| Value | Count | Frequency (%) |
| bal | 43395 | 4.8% |
| cin | 43395 | 4.8% |
| football | 39404 | 4.3% |
| ten | 38346 | 4.2% |
| kc | 38346 | 4.2% |
| gb | 37290 | 4.1% |
| was | 37290 | 4.1% |
| nyg | 34991 | 3.9% |
| car | 34991 | 3.9% |
| sea | 34111 | 3.8% |
| Other values (17) | 524733 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 279807 | 10.5% |
| N | 272580 | 10.3% |
| I | 195338 | 7.4% |
| E | 193292 | 7.3% |
| C | 174977 | 6.6% |
| L | 167497 | 6.3% |
| T | 134915 | 5.1% |
| B | 111463 | 4.2% |
| S | 97493 | 3.7% |
| H | 91872 | 3.5% |
| Other values (19) | 933300 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2337302 | |
| Lowercase Letter | 315232 | 11.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 279807 | |
| N | 272580 | |
| I | 195338 | 8.4% |
| E | 193292 | 8.3% |
| C | 174977 | 7.5% |
| L | 167497 | 7.2% |
| T | 134915 | 5.8% |
| B | 111463 | 4.8% |
| S | 97493 | 4.2% |
| H | 91872 | 3.9% |
| Other values (13) | 618068 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 78808 | |
| l | 78808 | |
| b | 39404 | |
| t | 39404 | |
| f | 39404 | |
| a | 39404 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2652534 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 279807 | 10.5% |
| N | 272580 | 10.3% |
| I | 195338 | 7.4% |
| E | 193292 | 7.3% |
| C | 174977 | 6.6% |
| L | 167497 | 6.3% |
| T | 134915 | 5.1% |
| B | 111463 | 4.2% |
| S | 97493 | 3.7% |
| H | 91872 | 3.5% |
| Other values (19) | 933300 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2652534 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 279807 | 10.5% |
| N | 272580 | 10.3% |
| I | 195338 | 7.4% |
| E | 193292 | 7.3% |
| C | 174977 | 6.6% |
| L | 167497 | 6.3% |
| T | 134915 | 5.1% |
| B | 111463 | 4.2% |
| S | 97493 | 3.7% |
| H | 91872 | 3.5% |
| Other values (19) | 933300 |
playDirection
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| left | |
|---|---|
| right |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.483377322 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4063249 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | left |
|---|---|
| 2nd row | left |
| 3rd row | left |
| 4th row | left |
| 5th row | left |
Common Values
| Value | Count | Frequency (%) |
| left | 468211 | |
| right | 438081 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| left | 468211 | |
| right | 438081 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 906292 | |
| l | 468211 | |
| e | 468211 | |
| f | 468211 | |
| r | 438081 | |
| i | 438081 | |
| g | 438081 | |
| h | 438081 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4063249 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 906292 | |
| l | 468211 | |
| e | 468211 | |
| f | 468211 | |
| r | 438081 | |
| i | 438081 | |
| g | 438081 | |
| h | 438081 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4063249 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 906292 | |
| l | 468211 | |
| e | 468211 | |
| f | 468211 | |
| r | 438081 | |
| i | 438081 | |
| g | 438081 | |
| h | 438081 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4063249 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 906292 | |
| l | 468211 | |
| e | 468211 | |
| f | 468211 | |
| r | 438081 | |
| i | 438081 | |
| g | 438081 | |
| h | 438081 |
x
Real number (ℝ≥0)
| Distinct | 11707 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.73619214 |
| Minimum | 0.58 |
|---|---|
| Maximum | 120.94 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0.58 |
|---|---|
| 5-th percentile | 21.29 |
| Q1 | 40.96 |
| median | 60.8 |
| Q3 | 80.36 |
| 95-th percentile | 100.32 |
| Maximum | 120.94 |
| Range | 120.36 |
| Interquartile range (IQR) | 39.4 |
Descriptive statistics
| Standard deviation | 24.59857675 |
|---|---|
| Coefficient of variation (CV) | 0.4050068976 |
| Kurtosis | -0.8639535791 |
| Mean | 60.73619214 |
| Median Absolute Deviation (MAD) | 19.69 |
| Skewness | -0.009987463377 |
| Sum | 55044725.05 |
| Variance | 605.0899781 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46.99 | 186 | < 0.1% |
| 65.9 | 174 | < 0.1% |
| 63.24 | 172 | < 0.1% |
| 85.36 | 172 | < 0.1% |
| 82.15 | 169 | < 0.1% |
| 47.85 | 168 | < 0.1% |
| 33.33 | 167 | < 0.1% |
| 59.7 | 167 | < 0.1% |
| 47.7 | 167 | < 0.1% |
| 48.34 | 166 | < 0.1% |
| Other values (11697) | 904584 |
| Value | Count | Frequency (%) |
| 0.58 | 1 | |
| 0.59 | 1 | |
| 0.63 | 1 | |
| 0.71 | 1 | |
| 0.73 | 1 | |
| 0.77 | 1 | |
| 0.78 | 2 | |
| 0.8 | 2 | |
| 0.83 | 1 | |
| 0.84 | 2 |
| Value | Count | Frequency (%) |
| 120.94 | 1 | |
| 120.47 | 1 | |
| 120.01 | 1 | |
| 119.81 | 1 | |
| 119.55 | 1 | |
| 119.49 | 1 | |
| 119.39 | 2 | |
| 119.29 | 1 | |
| 119.24 | 1 | |
| 119.2 | 1 |
y
Real number (ℝ)
| Distinct | 5422 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.81395279 |
| Minimum | -1.67 |
|---|---|
| Maximum | 57.72 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 53 |
| Negative (%) | < 0.1% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | -1.67 |
|---|---|
| 5-th percentile | 11.6 |
| Q1 | 22.04 |
| median | 26.8 |
| Q3 | 31.59 |
| 95-th percentile | 41.86 |
| Maximum | 57.72 |
| Range | 59.39 |
| Interquartile range (IQR) | 9.55 |
Descriptive statistics
| Standard deviation | 8.354167749 |
|---|---|
| Coefficient of variation (CV) | 0.3115604706 |
| Kurtosis | 0.3241012869 |
| Mean | 26.81395279 |
| Median Absolute Deviation (MAD) | 4.78 |
| Skewness | -0.009097800801 |
| Sum | 24301270.9 |
| Variance | 69.79211877 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29.81 | 981 | 0.1% |
| 29.82 | 952 | 0.1% |
| 29.83 | 948 | 0.1% |
| 23.81 | 942 | 0.1% |
| 23.87 | 927 | 0.1% |
| 29.74 | 917 | 0.1% |
| 23.83 | 909 | 0.1% |
| 29.75 | 909 | 0.1% |
| 23.78 | 908 | 0.1% |
| 23.85 | 907 | 0.1% |
| Other values (5412) | 896992 |
| Value | Count | Frequency (%) |
| -1.67 | 1 | |
| -1.31 | 1 | |
| -0.97 | 1 | |
| -0.93 | 1 | |
| -0.91 | 2 | |
| -0.87 | 1 | |
| -0.86 | 1 | |
| -0.79 | 1 | |
| -0.78 | 1 | |
| -0.69 | 1 |
| Value | Count | Frequency (%) |
| 57.72 | 1 | |
| 56.89 | 1 | |
| 56.07 | 1 | |
| 55.8 | 1 | |
| 55.59 | 1 | |
| 55.41 | 1 | |
| 55.31 | 1 | |
| 55.28 | 1 | |
| 55.27 | 1 | |
| 55.05 | 1 |
| Distinct | 2091 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.596570035 |
| Minimum | 0 |
|---|---|
| Maximum | 27.83 |
| Zeros | 60334 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.75 |
| median | 2.16 |
| Q3 | 3.85 |
| 95-th percentile | 6.79 |
| Maximum | 27.83 |
| Range | 27.83 |
| Interquartile range (IQR) | 3.1 |
Descriptive statistics
| Standard deviation | 2.391158449 |
|---|---|
| Coefficient of variation (CV) | 0.920891182 |
| Kurtosis | 13.63636117 |
| Mean | 2.596570035 |
| Median Absolute Deviation (MAD) | 1.52 |
| Skewness | 2.275058694 |
| Sum | 2353250.65 |
| Variance | 5.717638727 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 60334 | 6.7% |
| 0.01 | 14915 | 1.6% |
| 0.02 | 8560 | 0.9% |
| 0.03 | 6057 | 0.7% |
| 0.04 | 4944 | 0.5% |
| 0.05 | 4146 | 0.5% |
| 0.06 | 3720 | 0.4% |
| 0.07 | 3418 | 0.4% |
| 0.08 | 3184 | 0.4% |
| 0.09 | 3048 | 0.3% |
| Other values (2081) | 793966 |
| Value | Count | Frequency (%) |
| 0 | 60334 | |
| 0.01 | 14915 | 1.6% |
| 0.02 | 8560 | 0.9% |
| 0.03 | 6057 | 0.7% |
| 0.04 | 4944 | 0.5% |
| 0.05 | 4146 | 0.5% |
| 0.06 | 3720 | 0.4% |
| 0.07 | 3418 | 0.4% |
| 0.08 | 3184 | 0.4% |
| 0.09 | 3048 | 0.3% |
| Value | Count | Frequency (%) |
| 27.83 | 1 | |
| 27.67 | 1 | |
| 27.52 | 1 | |
| 27.46 | 1 | |
| 27.42 | 1 | |
| 27.38 | 1 | |
| 27.22 | 2 | |
| 27.21 | 1 | |
| 27.05 | 1 | |
| 26.99 | 1 |
| Distinct | 1497 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.798458025 |
| Minimum | 0 |
|---|---|
| Maximum | 30.03 |
| Zeros | 56293 |
| Zeros (%) | 6.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.71 |
| median | 1.54 |
| Q3 | 2.6 |
| 95-th percentile | 4.49 |
| Maximum | 30.03 |
| Range | 30.03 |
| Interquartile range (IQR) | 1.89 |
Descriptive statistics
| Standard deviation | 1.447153974 |
|---|---|
| Coefficient of variation (CV) | 0.8046637479 |
| Kurtosis | 5.28825985 |
| Mean | 1.798458025 |
| Median Absolute Deviation (MAD) | 0.92 |
| Skewness | 1.350708611 |
| Sum | 1629928.12 |
| Variance | 2.094254626 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 56293 | 6.2% |
| 0.01 | 11832 | 1.3% |
| 0.02 | 6598 | 0.7% |
| 0.03 | 5140 | 0.6% |
| 0.04 | 4086 | 0.5% |
| 0.05 | 3443 | 0.4% |
| 0.06 | 2936 | 0.3% |
| 0.96 | 2864 | 0.3% |
| 1.32 | 2839 | 0.3% |
| 1 | 2837 | 0.3% |
| Other values (1487) | 807424 |
| Value | Count | Frequency (%) |
| 0 | 56293 | |
| 0.01 | 11832 | 1.3% |
| 0.02 | 6598 | 0.7% |
| 0.03 | 5140 | 0.6% |
| 0.04 | 4086 | 0.5% |
| 0.05 | 3443 | 0.4% |
| 0.06 | 2936 | 0.3% |
| 0.07 | 2611 | 0.3% |
| 0.08 | 2470 | 0.3% |
| 0.09 | 2157 | 0.2% |
| Value | Count | Frequency (%) |
| 30.03 | 1 | |
| 26.13 | 1 | |
| 24.68 | 1 | |
| 24.61 | 1 | |
| 23.26 | 1 | |
| 22.93 | 1 | |
| 22.5 | 1 | |
| 21.55 | 1 | |
| 21.32 | 1 | |
| 21.29 | 1 |
| Distinct | 517 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2631815022 |
| Minimum | 0 |
|---|---|
| Maximum | 6.42 |
| Zeros | 60300 |
| Zeros (%) | 6.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.08 |
| median | 0.22 |
| Q3 | 0.39 |
| 95-th percentile | 0.68 |
| Maximum | 6.42 |
| Range | 6.42 |
| Interquartile range (IQR) | 0.31 |
Descriptive statistics
| Standard deviation | 0.2550544709 |
|---|---|
| Coefficient of variation (CV) | 0.9691200511 |
| Kurtosis | 46.29641698 |
| Mean | 0.2631815022 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | 4.017486438 |
| Sum | 238519.29 |
| Variance | 0.0650527831 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 60300 | 6.7% |
| 0.01 | 48320 | 5.3% |
| 0.02 | 26988 | 3.0% |
| 0.03 | 21073 | 2.3% |
| 0.04 | 18584 | 2.1% |
| 0.05 | 17004 | 1.9% |
| 0.19 | 16666 | 1.8% |
| 0.17 | 16557 | 1.8% |
| 0.18 | 16415 | 1.8% |
| 0.16 | 16409 | 1.8% |
| Other values (507) | 647976 |
| Value | Count | Frequency (%) |
| 0 | 60300 | |
| 0.01 | 48320 | |
| 0.02 | 26988 | |
| 0.03 | 21073 | 2.3% |
| 0.04 | 18584 | 2.1% |
| 0.05 | 17004 | 1.9% |
| 0.06 | 16101 | 1.8% |
| 0.07 | 15838 | 1.7% |
| 0.08 | 15513 | 1.7% |
| 0.09 | 15559 | 1.7% |
| Value | Count | Frequency (%) |
| 6.42 | 1 | |
| 6.4 | 2 | |
| 6.38 | 1 | |
| 6.16 | 1 | |
| 6.12 | 1 | |
| 6.03 | 1 | |
| 6.01 | 1 | |
| 5.89 | 1 | |
| 5.88 | 1 | |
| 5.85 | 1 |
| Distinct | 36001 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 39404 |
| Missing (%) | 4.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 178.3109756 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 28.51 |
| Q1 | 87.23 |
| median | 177.66 |
| Q3 | 267.98 |
| 95-th percentile | 332 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 180.75 |
Descriptive statistics
| Standard deviation | 100.0687965 |
|---|---|
| Coefficient of variation (CV) | 0.561203797 |
| Kurtosis | -1.348592003 |
| Mean | 178.3109756 |
| Median Absolute Deviation (MAD) | 90.37 |
| Skewness | 0.01879387761 |
| Sum | 154575645 |
| Variance | 10013.76404 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 1259 | 0.1% |
| 267.87 | 98 | < 0.1% |
| 271.18 | 93 | < 0.1% |
| 266.97 | 86 | < 0.1% |
| 260.04 | 85 | < 0.1% |
| 82.15 | 84 | < 0.1% |
| 269.28 | 83 | < 0.1% |
| 263.02 | 82 | < 0.1% |
| 97.87 | 82 | < 0.1% |
| 96.17 | 81 | < 0.1% |
| Other values (35991) | 864855 | |
| (Missing) | 39404 | 4.3% |
| Value | Count | Frequency (%) |
| 0 | 7 | < 0.1% |
| 0.01 | 25 | |
| 0.02 | 14 | |
| 0.03 | 20 | |
| 0.04 | 15 | |
| 0.05 | 20 | |
| 0.06 | 16 | |
| 0.07 | 17 | |
| 0.08 | 19 | |
| 0.09 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 12 | |
| 359.99 | 12 | |
| 359.98 | 13 | |
| 359.97 | 14 | |
| 359.96 | 15 | |
| 359.95 | 20 | |
| 359.94 | 9 | |
| 359.93 | 11 | |
| 359.92 | 9 | |
| 359.91 | 17 |
| Distinct | 36001 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 39404 |
| Missing (%) | 4.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 181.2278835 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 13 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 23.7 |
| Q1 | 91.13 |
| median | 180.76 |
| Q3 | 271.31 |
| 95-th percentile | 337.62 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 180.18 |
Descriptive statistics
| Standard deviation | 101.3668017 |
|---|---|
| Coefficient of variation (CV) | 0.559333364 |
| Kurtosis | -1.283033517 |
| Mean | 181.2278835 |
| Median Absolute Deviation (MAD) | 90.09 |
| Skewness | -0.005686777698 |
| Sum | 157104277.4 |
| Variance | 10275.22849 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90.36 | 63 | < 0.1% |
| 269.15 | 63 | < 0.1% |
| 270.95 | 62 | < 0.1% |
| 93.97 | 61 | < 0.1% |
| 270.75 | 61 | < 0.1% |
| 266.68 | 60 | < 0.1% |
| 97.76 | 60 | < 0.1% |
| 88.01 | 60 | < 0.1% |
| 267.27 | 60 | < 0.1% |
| 90.37 | 59 | < 0.1% |
| Other values (35991) | 866279 | |
| (Missing) | 39404 | 4.3% |
| Value | Count | Frequency (%) |
| 0 | 13 | |
| 0.01 | 22 | |
| 0.02 | 25 | |
| 0.03 | 22 | |
| 0.04 | 21 | |
| 0.05 | 24 | |
| 0.06 | 23 | |
| 0.07 | 26 | |
| 0.08 | 18 | |
| 0.09 | 12 |
| Value | Count | Frequency (%) |
| 360 | 5 | < 0.1% |
| 359.99 | 28 | |
| 359.98 | 16 | |
| 359.97 | 23 | |
| 359.96 | 9 | < 0.1% |
| 359.95 | 17 | |
| 359.94 | 18 | |
| 359.93 | 18 | |
| 359.92 | 30 | |
| 359.91 | 17 |
event
Categorical
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| None | |
|---|---|
| ball_snap | 20999 |
| pass_forward | 18469 |
| autoevent_ballsnap | 8947 |
| autoevent_passforward | 8602 |
| Other values (17) | 10810 |
Length
| Max length | 25 |
|---|---|
| Median length | 4 |
| Mean length | 4.653080905 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4217050 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | None |
|---|---|
| 2nd row | None |
| 3rd row | None |
| 4th row | None |
| 5th row | None |
Common Values
| Value | Count | Frequency (%) |
| None | 838465 | |
| ball_snap | 20999 | 2.3% |
| pass_forward | 18469 | 2.0% |
| autoevent_ballsnap | 8947 | 1.0% |
| autoevent_passforward | 8602 | 0.9% |
| play_action | 5060 | 0.6% |
| run | 1265 | 0.1% |
| qb_sack | 1150 | 0.1% |
| pass_arrived | 851 | 0.1% |
| line_set | 552 | 0.1% |
| Other values (12) | 1932 | 0.2% |
Length
| Value | Count | Frequency (%) |
| none | 838465 | |
| ball_snap | 20999 | 2.3% |
| pass_forward | 18469 | 2.0% |
| autoevent_ballsnap | 8947 | 1.0% |
| autoevent_passforward | 8602 | 0.9% |
| play_action | 5060 | 0.6% |
| run | 1265 | 0.1% |
| qb_sack | 1150 | 0.1% |
| pass_arrived | 851 | 0.1% |
| line_set | 552 | 0.1% |
| Other values (12) | 1932 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 895574 | |
| o | 890100 | |
| e | 877818 | |
| N | 838465 | |
| a | 146740 | 3.5% |
| s | 89700 | 2.1% |
| _ | 67114 | 1.6% |
| l | 65596 | 1.6% |
| p | 64722 | 1.5% |
| r | 58443 | 1.4% |
| Other values (15) | 222778 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3311471 | |
| Uppercase Letter | 838465 | 19.9% |
| Connector Punctuation | 67114 | 1.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 895574 | |
| o | 890100 | |
| e | 877818 | |
| a | 146740 | 4.4% |
| s | 89700 | 2.7% |
| l | 65596 | 2.0% |
| p | 64722 | 2.0% |
| r | 58443 | 1.8% |
| t | 44252 | 1.3% |
| b | 31395 | 0.9% |
| Other values (13) | 147131 | 4.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 838465 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 67114 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4149936 | |
| Common | 67114 | 1.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 895574 | |
| o | 890100 | |
| e | 877818 | |
| N | 838465 | |
| a | 146740 | 3.5% |
| s | 89700 | 2.2% |
| l | 65596 | 1.6% |
| p | 64722 | 1.6% |
| r | 58443 | 1.4% |
| t | 44252 | 1.1% |
| Other values (14) | 178526 | 4.3% |
Common
| Value | Count | Frequency (%) |
| _ | 67114 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4217050 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 895574 | |
| o | 890100 | |
| e | 877818 | |
| N | 838465 | |
| a | 146740 | 3.5% |
| s | 89700 | 2.1% |
| _ | 67114 | 1.6% |
| l | 65596 | 1.6% |
| p | 64722 | 1.5% |
| r | 58443 | 1.4% |
| Other values (15) | 222778 | 5.3% |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| gameId | playId | nflId | frameId | time | jerseyNumber | team | playDirection | x | y | s | a | dis | o | dir | event | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021102100 | 56 | 35459.0 | 1 | 2021-10-22T00:23:17.300 | 22.0 | DEN | left | 75.42 | 20.77 | 0.97 | 1.03 | 0.09 | 60.75 | 64.69 | None |
| 1 | 2021102100 | 56 | 35459.0 | 2 | 2021-10-22T00:23:17.400 | 22.0 | DEN | left | 75.51 | 20.82 | 1.09 | 0.97 | 0.11 | 63.06 | 60.90 | None |
| 2 | 2021102100 | 56 | 35459.0 | 3 | 2021-10-22T00:23:17.500 | 22.0 | DEN | left | 75.61 | 20.88 | 1.23 | 0.79 | 0.12 | 63.06 | 61.13 | None |
| 3 | 2021102100 | 56 | 35459.0 | 4 | 2021-10-22T00:23:17.600 | 22.0 | DEN | left | 75.73 | 20.94 | 1.30 | 0.57 | 0.13 | 62.35 | 60.85 | None |
| 4 | 2021102100 | 56 | 35459.0 | 5 | 2021-10-22T00:23:17.700 | 22.0 | DEN | left | 75.84 | 21.01 | 1.33 | 0.37 | 0.13 | 60.65 | 60.99 | None |
| 5 | 2021102100 | 56 | 35459.0 | 6 | 2021-10-22T00:23:17.800 | 22.0 | DEN | left | 75.96 | 21.07 | 1.36 | 0.22 | 0.13 | 58.76 | 61.66 | ball_snap |
| 6 | 2021102100 | 56 | 35459.0 | 7 | 2021-10-22T00:23:17.900 | 22.0 | DEN | left | 76.07 | 21.14 | 1.35 | 0.05 | 0.13 | 57.80 | 60.75 | None |
| 7 | 2021102100 | 56 | 35459.0 | 8 | 2021-10-22T00:23:18.000 | 22.0 | DEN | left | 76.19 | 21.21 | 1.30 | 0.34 | 0.13 | 57.80 | 58.86 | None |
| 8 | 2021102100 | 56 | 35459.0 | 9 | 2021-10-22T00:23:18.100 | 22.0 | DEN | left | 76.29 | 21.28 | 1.29 | 0.48 | 0.13 | 59.17 | 55.39 | None |
| 9 | 2021102100 | 56 | 35459.0 | 10 | 2021-10-22T00:23:18.200 | 22.0 | DEN | left | 76.40 | 21.36 | 1.27 | 0.58 | 0.13 | 60.21 | 52.44 | None |
Last rows
| gameId | playId | nflId | frameId | time | jerseyNumber | team | playDirection | x | y | s | a | dis | o | dir | event | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 906282 | 2021102500 | 3998 | NaN | 66 | 2021-10-26T03:17:05.400 | NaN | football | left | 114.51 | 13.75 | 3.19 | 1.19 | 0.32 | NaN | NaN | None |
| 906283 | 2021102500 | 3998 | NaN | 67 | 2021-10-26T03:17:05.500 | NaN | football | left | 114.53 | 13.43 | 3.14 | 1.10 | 0.32 | NaN | NaN | None |
| 906284 | 2021102500 | 3998 | NaN | 68 | 2021-10-26T03:17:05.600 | NaN | football | left | 114.56 | 13.12 | 3.06 | 1.11 | 0.31 | NaN | NaN | None |
| 906285 | 2021102500 | 3998 | NaN | 69 | 2021-10-26T03:17:05.700 | NaN | football | left | 114.59 | 12.82 | 2.97 | 1.16 | 0.30 | NaN | NaN | None |
| 906286 | 2021102500 | 3998 | NaN | 70 | 2021-10-26T03:17:05.800 | NaN | football | left | 114.63 | 12.53 | 2.86 | 1.20 | 0.29 | NaN | NaN | autoevent_passforward |
| 906287 | 2021102500 | 3998 | NaN | 71 | 2021-10-26T03:17:05.900 | NaN | football | left | 112.93 | 14.52 | 22.04 | 0.44 | 2.62 | NaN | NaN | pass_forward |
| 906288 | 2021102500 | 3998 | NaN | 72 | 2021-10-26T03:17:06.000 | NaN | football | left | 111.34 | 16.07 | 21.95 | 1.40 | 2.22 | NaN | NaN | None |
| 906289 | 2021102500 | 3998 | NaN | 73 | 2021-10-26T03:17:06.100 | NaN | football | left | 109.74 | 17.60 | 21.81 | 2.02 | 2.21 | NaN | NaN | None |
| 906290 | 2021102500 | 3998 | NaN | 74 | 2021-10-26T03:17:06.200 | NaN | football | left | 108.17 | 19.12 | 21.66 | 2.39 | 2.19 | NaN | NaN | None |
| 906291 | 2021102500 | 3998 | NaN | 75 | 2021-10-26T03:17:06.300 | NaN | football | left | 106.62 | 20.63 | 21.53 | 2.68 | 2.17 | NaN | NaN | None |